USE [BMIG_MENSUAL_POST_CADENA]

 -- creating the store procedure
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = 'WASP_M0007_CABECERA_VALORES_SEGUROS'
	   AND 	  type = 'P') 
	DROP PROCEDURE [dbo].[WASP_M0007_CABECERA_VALORES_SEGUROS]
GO
create PROCEDURE [dbo].[WASP_M0007_CABECERA_VALORES_SEGUROS]
(@FECHA_INICIO CHAR(8), @FECHA_TERMINO AS CHAR(8)) AS
begin
  SELECT     
    a.ppsuc
  , a.ppcta
  , a.ppoper
  , a.ppimp11
  , a.ppimp12
  , a.ppimp13
  , a.ppimp14
  , a.ppimp15
  , a.ppimp16
  , a.ppimp17
  , a.ppimp18
  , a.ppimp19
  into dbo.cabecera_valores_segurosIP_aux_ant
  FROM dbo.fsd611 AS a WITH (nolock) 
  CROSS JOIN dbo.fsd601 AS b WITH (nolock) 
  CROSS JOIN dbo.JT73109 AS d WITH (nolock)
  WHERE (a.pptipo = '') 
  AND (a.ppexte = 0) 
  AND (a.pgcod = b.pgcod) 
  AND (a.ppmod = b.ppmod) 
  AND (a.ppsuc = b.ppsuc) 
  AND (a.ppmda = b.ppmda) 
  AND (a.ppcta = b.ppcta) 
  AND (a.ppoper = b.ppoper) 
  AND (a.ppsbop = b.ppsbop) 
  AND (a.pptope = b.pptope) 
  AND (b.d601co = 'S') 
  AND (d.JT73109FPA = a.ppoper) 
  AND (d.JT73109SUC = a.ppsuc) 
  AND (d.JT73109FAP BETWEEN @FECHA_INICIO AND @FECHA_TERMINO)
  GROUP BY a.ppsuc
  , a.ppcta
  , a.ppoper
  , a.ppimp11
  , a.ppimp12
  , a.ppimp13
  , a.ppimp14
  , a.ppimp15
  , a.ppimp16
  , a.ppimp17
  , a.ppimp18
  , a.ppimp19
  
  SELECT a.ppsuc
  , a.ppcta
  , a.ppoper
  , a.ppimp11
  , a.ppimp12
  , a.ppimp13
  , a.ppimp14
  , a.ppimp15
  , a.ppimp16
  , a.ppimp17
  , a.ppimp18
  , a.ppimp19
  into dbo.cabecera_valores_segurosIP_ant
  FROM dbo.cabecera_valores_segurosIP_aux_ant AS a 
  CROSS JOIN dbo.fsd010 AS c WITH (nolock)
  WHERE (a.ppsuc = c.aosuc) 
  AND (a.ppcta = c.aocta) 
  AND (a.ppoper = c.aooper) 
  AND (c.aosbop = 0)
  
End  